package cn.swust.score.dao;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update; 
@Mapper
public interface DelDataDao {
     @Delete("delete from candidate_score")
	int deleteGrade();
     @Delete("delete from candidate_stag_info ")
  	int deleteStage();
     @Delete("delete from candidate")
      int deleteCandidate();
      @Delete("delete from rater where id != 0")
      int deleteRater();
      @Update("alter table candidate AUTO_INCREMENT=1")
      void alterCandidate();
      
      @Update("update  rater set curr_stage_id = 1,curr_candidate_sort=0")
      void updateRater();
      
      @Update("alter table rater AUTO_INCREMENT=1")
      void alterRater();
}
